<?php

if (!defined('BASEPATH')) exit('No direct script access allowed');

/* v3.1.0  */
 
class Home extends M_Controller {
    /**
     * 首页
     */
    public function index() {
//        var_dump(send_posts($url,json_encode($param)));exit;
//        print_r($param);exit;
//        $this->__gw_index();
//        $this->_indexgw();
        $useragent = $_SERVER['HTTP_USER_AGENT'];
        if (preg_match('/(android|bb\d+|meego).+mobile|avantgo|bada\/|blackberry|blazer|compal|elaine|fennec|hiptop|iemobile|ip(hone|od)|iris|kindle|lge |maemo|midp|mmp|mobile.+firefox|netfront|opera m(ob|in)i|palm( os)?|phone|p(ixi|re)\/|plucker|pocket|psp|series(4|6)0|symbian|treo|up\.(browser|link)|vodafone|wap|windows ce|xda|xiino/i', $useragent) || preg_match('/1207|6310|6590|3gso|4thp|50[1-6]i|770s|802s|a wa|abac|ac(er|oo|s\-)|ai(ko|rn)|al(av|ca|co)|amoi|an(ex|ny|yw)|aptu|ar(ch|go)|as(te|us)|attw|au(di|\-m|r |s )|avan|be(ck|ll|nq)|bi(lb|rd)|bl(ac|az)|br(e|v)w|bumb|bw\-(n|u)|c55\/|capi|ccwa|cdm\-|cell|chtm|cldc|cmd\-|co(mp|nd)|craw|da(it|ll|ng)|dbte|dc\-s|devi|dica|dmob|do(c|p)o|ds(12|\-d)|el(49|ai)|em(l2|ul)|er(ic|k0)|esl8|ez([4-7]0|os|wa|ze)|fetc|fly(\-|_)|g1 u|g560|gene|gf\-5|g\-mo|go(\.w|od)|gr(ad|un)|haie|hcit|hd\-(m|p|t)|hei\-|hi(pt|ta)|hp( i|ip)|hs\-c|ht(c(\-| |_|a|g|p|s|t)|tp)|hu(aw|tc)|i\-(20|go|ma)|i230|iac( |\-|\/)|ibro|idea|ig01|ikom|im1k|inno|ipaq|iris|ja(t|v)a|jbro|jemu|jigs|kddi|keji|kgt( |\/)|klon|kpt |kwc\-|kyo(c|k)|le(no|xi)|lg( g|\/(k|l|u)|50|54|\-[a-w])|libw|lynx|m1\-w|m3ga|m50\/|ma(te|ui|xo)|mc(01|21|ca)|m\-cr|me(rc|ri)|mi(o8|oa|ts)|mmef|mo(01|02|bi|de|do|t(\-| |o|v)|zz)|mt(50|p1|v )|mwbp|mywa|n10[0-2]|n20[2-3]|n30(0|2)|n50(0|2|5)|n7(0(0|1)|10)|ne((c|m)\-|on|tf|wf|wg|wt)|nok(6|i)|nzph|o2im|op(ti|wv)|oran|owg1|p800|pan(a|d|t)|pdxg|pg(13|\-([1-8]|c))|phil|pire|pl(ay|uc)|pn\-2|po(ck|rt|se)|prox|psio|pt\-g|qa\-a|qc(07|12|21|32|60|\-[2-7]|i\-)|qtek|r380|r600|raks|rim9|ro(ve|zo)|s55\/|sa(ge|ma|mm|ms|ny|va)|sc(01|h\-|oo|p\-)|sdk\/|se(c(\-|0|1)|47|mc|nd|ri)|sgh\-|shar|sie(\-|m)|sk\-0|sl(45|id)|sm(al|ar|b3|it|t5)|so(ft|ny)|sp(01|h\-|v\-|v )|sy(01|mb)|t2(18|50)|t6(00|10|18)|ta(gt|lk)|tcl\-|tdg\-|tel(i|m)|tim\-|t\-mo|to(pl|sh)|ts(70|m\-|m3|m5)|tx\-9|up(\.b|g1|si)|utst|v400|v750|veri|vi(rg|te)|vk(40|5[0-3]|\-v)|vm40|voda|vulc|vx(52|53|60|61|70|80|81|83|85|98)|w3c(\-| )|webc|whit|wi(g |nc|nw)|wmlb|wonu|x700|yas\-|your|zeto|zte\-/i',
                substr($useragent, 0, 4))) {
            // 手机
//            return 1;
            $this->_indexMobile();
        } else {
             $this->_indexgw();
            // 电脑
//            return 0;
        }
//        $this->_indexc();
//$dir = './uploadfile/高新区 2018级 3820.xls';
//        $dir =  './uploadfile/test.xls';
//print_r(importExecl($dir));exit;


    }
    //导入excel
    public function import(){
        set_time_limit(0);
//        print_r($_FILES);exit;
        if(!empty($_FILES['files']['name'])){
            $filename = $_FILES['files']['name'];
            $tmp_name = $_FILES['files']['tmp_name'];
            $arr = explode(".",$filename);
            $file_name = $arr[0];
            $file_type = $arr[1];
            $data = importExeclss($tmp_name, $file_name ,$file_type);
//            $data =  importExecl($tmp_name);
//            print_r($data);exit;
            $result = $this->db->insert_batch('students',$data);
//            $result = $this->db->insert_batch('students-1',$data);
//            var_dump($result);exit;
            if($result){
                echo "导入成功";
            }else{
                echo "导入失败";
            }
        }
        $this->template->display('../gw/import.html');
    }
    //导入excel
    public function importbf(){
        set_time_limit(0);
//        print_r($_FILES);exit;
        if(!empty($_FILES['files']['name'])){
            $filename = $_FILES['files']['name'];
            $tmp_name = $_FILES['files']['tmp_name'];
            $arr = explode(".",$filename);
            $file_name = $arr[0];
            $file_type = $arr[1];
            $data = importExeclss($tmp_name, $file_name ,$file_type);
//            $data =  importExecl($tmp_name);
//            print_r($data);exit;
//            $result = $this->db->insert_batch('students',$data);
            $result = $this->db->insert_batch('students-1',$data);
//            var_dump($result);exit;
            if($result){
                echo "导入成功";
            }else{
                echo "导入失败";
            }
        }
        $this->template->display('../gw/import.html');
    }

    //
    public function importData(){
        $url = "https://open.workec.com/customer/addCustomer";
        header("content-type: application/json");

        $data = $this->db->where('id>51167')->get('students')->result_array();
//        print_r($data);exit;
        if(count($data)>0){
            foreach($data as $studesnts){

                if(!empty($studesnts)){
                    $ecArr = array();
                    $ss = array();
                    foreach($studesnts as $key=>$val){
                        if($key == "name"){
                            if(!empty($val)){
                                $ecArr['f_name'] = $val;
//                        $ss['81157099'] = $val;
                            }
                        }else if($key == "birthday"){
                            if(!empty($val)){
                                $ecArr['f_birthday'] = $val;
                            }
                        }else if($key == 'phone'){
                            //判断是手机 还是电话
                            if(!empty($val)){
                                if(is_mobile($val)){
                                    $ecArr['f_mobile'] = $val;
                                }else{
                                    $ecArr['f_phone'] = $val;
                                }
                            }
                        }else if($key == 'sex'){
                            if($val == '男'){
                                $ecArr['f_gender'] = 1;
                            }else if($val == '女'){
                                $ecArr['f_gender'] = 2;
                            }else{
                                $ecArr['f_gender'] = 0;
                            }
                        }else if($key == 'school'){
                            if(!empty($val)){
                                $ecArr['81157088'] = $val;
                                $ss['81157088'] = array('option_id'=>'','type'=>'1');
//                        $ecArr['81157088'] = $val;
                            }

                        }else if($key == 'grade'){
                            if(!empty($val)){
//                        $ss['81157087'] = $val;
                                $ss['81157087'] =  array('option_id'=>'','type'=>'1',);
                                $ecArr['81157087'] = $val;
                            }
                        }else if($key == 'province'){
                            if(!empty($val)){
                                $ecArr['f_company_province'] = $val;
                            }
                        }
                    }
                    $ecArr['f_company_city'] = "成都";
                    $ecArr['f_company_country'] = "中国";
                    $ecArr['optUserId'] = '7173319';
                    $ecArr['81157096'] = '客户资料库';
                    $ss['81157096'] =  array('option_id'=>'','type'=>'4');
                    $ecArr['customFieldMapping']  = ($ss);

                }


                $apps = array("appId"=>"331758674819153920","appSecret"=>"FxJ9QAyzBxwnm9E5u1M");
                $arrs  = ec_getToken("https://open.workec.com/auth/accesstoken",json_encode($apps));
                $tok = json_decode($arrs,true);
                $token = $tok['data']['accessToken'];
//        $construct = ec_getData("https://open.workec.com/user/structure",json_encode($apps),array("Authorization:$token", "CORP_ID:7148694"));
//        print_r($construct);exit;
//        print_r(array("Authorization:$token", "CORP_ID:7148694"));exit;
//echo json_encode($ecArr);exit;
                $result = ec_getData($url, json_encode($ecArr),array("Authorization:$token", "CORP_ID:7148694"));
                var_dump($result);


            }
        }

    }
    /**
     * 批量创建数据
    */
    public function importList(){
        $url = "https://open.workec.com/customer/create";
        header("content-type: application/json");

        $data = $this->db->where('1=1')->get('students')->result_array();
//        print_r($data);exit;
        $list = array();
        if(count($data)>0){
            foreach($data as $k=>$studesnts){
                    if(!empty($studesnts)){
                        $customFieldMapping = array();
                        $fieldValueList = array();
                        $fieldNameMapping = array();
                        foreach($studesnts as $key=>$val){
                            if($key == "name"){
                                if(!empty($val)){
                                    $fieldValueList[] = $val;
                                    $fieldNameMapping[] = 'f_name';
                                }else{
                                    $fieldValueList[] = '无名';
                                    $fieldNameMapping[] = 'f_name';
                                }
                            }else if($key == "birthday"){
                                if(!empty($val)){
                                    $fieldValueList[] = $val;
                                    $fieldNameMapping[] = 'f_birthday';

                                }
                            }else if($key == 'phone'){
                                //判断是手机 还是电话
                                if(!empty($val)){
                                    if(is_mobile($val)){
//                                    $ecArr['f_mobile'] = $val;
                                        $fieldValueList[] = $val;
                                        $fieldNameMapping[] = 'f_mobile';
                                    }else{
//                                    $ecArr['f_phone'] = $val;
                                        $fieldValueList[] = $val;
                                        $fieldNameMapping[] = 'f_phone';
                                    }
                                }
                            }else if($key == 'sex'){
                                if($val == '男'){
//                                $ecArr['f_gender'] = 1;
                                    $fieldValueList[] = 1;
                                    $fieldNameMapping[] = 'f_gender';
                                }else if($val == '女'){
//                                $ecArr['f_gender'] = 2;
                                    $fieldValueList[] = 2;
                                    $fieldNameMapping[] = 'f_gender';
                                }else{
//                                $ecArr['f_gender'] = 0;
                                    $fieldValueList[] = 1;
                                    $fieldNameMapping[] = 'f_gender';
                                }
                            }else if($key == 'school'){
                                if(!empty($val)){
                                    $fieldNameMapping[] = '81157088';
                                    $customFieldMapping['81157088'] = array('option_id'=>'','type'=>'1');
                                    $fieldValueList[] = $val;
                                }

                            }else if($key == 'grade'){
                                if(!empty($val)){
                                    $fieldNameMapping[] = '81157087';
                                    $customFieldMapping['81157087']= array('option_id'=>'','type'=>'1');
                                    $fieldValueList[] = $val;

                                }
                            }else if($key == 'province'){
                                if(!empty($val)){
                                    $fieldNameMapping[] = 'f_company_province';
                                    $fieldValueList[] = $val;
                                }
                            }

                        }
//                    $fieldValueList[] = '成都';
//                    $fieldNameMapping[] = 'f_company_city';
                        $fieldValueList[] = '中国';
                        $fieldNameMapping[] = 'f_company_country';

                        $fieldValueList[] = '客户资料库';
                        $fieldNameMapping[] = '81157096';
                        $customFieldMapping['81157096']= array('option_id'=>'','type'=>'4');


                        $list['fieldValueList'][] = $fieldValueList;
                        $list['customFieldMapping'] = $customFieldMapping;

                        if(($k+1)%50 === 0){
                            $list['optUserId'] = '7173319';

                            $list['fieldNameMapping'] = $fieldNameMapping;
                            $apps = array("appId"=>"331758674819153920","appSecret"=>"FxJ9QAyzBxwnm9E5u1M");
                            $arrs  = ec_getToken("https://open.workec.com/auth/accesstoken",json_encode($apps));
                            $tok = json_decode($arrs,true);
                            $token = $tok['data']['accessToken'];
//                            echo json_encode($list);exit;
                            $result = ec_getData($url, json_encode($list),array("Authorization:$token", "CORP_ID:7148694"));
                            $list = array();
                            var_dump($result);
                        }
                    }



                }


            }

    }

}